Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	7273
Missing cells	5667
Missing cells (%)	6.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	738.8 KiB
Average record size in memory	104.0 B

Variable types

Categorical	2
Numeric	11

Alerts

`Symbol` has a high cardinality: 2240 distinct values	High cardinality
`ESG Score` is highly correlated with `Environmental Pillar Score` and 2 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Governance Pillar Score` is highly correlated with `ESG Score`	High correlation
`semi-variance (down)` is highly correlated with `VaR (95%)`	High correlation
`VaR (95%)` is highly correlated with `semi-variance (down)`	High correlation
`ESG Score` is highly correlated with `Environmental Pillar Score` and 2 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Governance Pillar Score` is highly correlated with `ESG Score`	High correlation
`semi-variance (down)` is highly correlated with `VaR (95%)`	High correlation
`VaR (95%)` is highly correlated with `semi-variance (down)`	High correlation
`ESG Score` is highly correlated with `Environmental Pillar Score` and 1 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`semi-variance (down)` is highly correlated with `VaR (95%)`	High correlation
`VaR (95%)` is highly correlated with `semi-variance (down)`	High correlation
`ESG Score` is highly correlated with `Environmental Pillar Score` and 2 other fields	High correlation
`Environmental Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Social Pillar Score` is highly correlated with `ESG Score` and 1 other fields	High correlation
`Governance Pillar Score` is highly correlated with `ESG Score`	High correlation
`mean-return` is highly correlated with `VaR (95%)`	High correlation
`semi-variance (down)` is highly correlated with `VaR (95%)`	High correlation
`kurtosis` is highly correlated with `skew`	High correlation
`skew` is highly correlated with `kurtosis`	High correlation
`VaR (95%)` is highly correlated with `mean-return` and 1 other fields	High correlation
`D(ESG, kurtosis)` has 4336 (59.6%) missing values	Missing
`D(ESG, VaR)` has 1331 (18.3%) missing values	Missing
`semi-variance (down)` is highly skewed (γ1 = 43.67768601)	Skewed
`Symbol` is uniformly distributed	Uniform
`ESG Score` has unique values	Unique
`semi-variance (down)` has unique values	Unique
`kurtosis` has unique values	Unique
`skew` has unique values	Unique

Reproduction

Analysis started	2022-09-29 03:27:04.743651
Analysis finished	2022-09-29 03:27:17.590226
Duration	12.85 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Symbol
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	2240
Distinct (%)	30.8%
Missing	0
Missing (%)	0.0%
Memory size	56.9 KiB

KINS.OQ	5
HWKN.OQ	5
HOFT.OQ	5
HOLX.OQ	5
HOUS.N	5
Other values (2235)	7248

Length

Max length	8
Median length	7
Mean length	5.834593703
Min length	3

Characters and Unicode

Total characters	42435
Distinct characters	35
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	409 ?
Unique (%)	5.6%

Sample

1st row	360.AX
2nd row	360.AX
3rd row	A.N
4th row	A.N
5th row	A.N

Common Values

Value	Count	Frequency (%)
KINS.OQ	5	0.1%
HWKN.OQ	5	0.1%
HOFT.OQ	5	0.1%
HOLX.OQ	5	0.1%
HOUS.N	5	0.1%
HP.N	5	0.1%
HPP.N	5	0.1%
HPQ.N	5	0.1%
HRI.N	5	0.1%
HRTG.N	5	0.1%
Other values (2230)	7223	99.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
kins.oq	5	0.1%
mei.n	5	0.1%
met.n	5	0.1%
meta.oq	5	0.1%
mgm.n	5	0.1%
mgpi.oq	5	0.1%
mhh.a	5	0.1%
mho.n	5	0.1%
mkc.n	5	0.1%
mlab.oq	5	0.1%
Other values (2230)	7223	99.3%

Most occurring characters

Value	Count	Frequency (%)
.	7273	17.1%
N	5470	12.9%
O	3982	9.4%
Q	3090	7.3%
C	1907	4.5%
A	1814	4.3%
S	1654	3.9%
T	1583	3.7%
R	1569	3.7%
M	1247	2.9%
Other values (25)	12846	30.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	35120	82.8%
Other Punctuation	7273	17.1%
Lowercase Letter	33	0.1%
Decimal Number	6	< 0.1%
Connector Punctuation	3	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	5470	15.6%
O	3982	11.3%
Q	3090	8.8%
C	1907	5.4%
A	1814	5.2%
S	1654	4.7%
T	1583	4.5%
R	1569	4.5%
M	1247	3.6%
I	1244	3.5%
Other values (16)	11560	32.9%

Lowercase Letter

Value	Count	Frequency (%)
a	20	60.6%
b	9	27.3%
p	3	9.1%
q	1	3.0%

Decimal Number

Value	Count	Frequency (%)
3	2	33.3%
6	2	33.3%
0	2	33.3%

Other Punctuation

Value	Count	Frequency (%)
.	7273	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35153	82.8%
Common	7282	17.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	5470	15.6%
O	3982	11.3%
Q	3090	8.8%
C	1907	5.4%
A	1814	5.2%
S	1654	4.7%
T	1583	4.5%
R	1569	4.5%
M	1247	3.5%
I	1244	3.5%
Other values (20)	11593	33.0%

Common

Value	Count	Frequency (%)
.	7273	99.9%
_	3	< 0.1%
3	2	< 0.1%
6	2	< 0.1%
0	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42435	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	7273	17.1%
N	5470	12.9%
O	3982	9.4%
Q	3090	7.3%
C	1907	4.5%
A	1814	4.3%
S	1654	3.9%
T	1583	3.7%
R	1569	3.7%
M	1247	2.9%
Other values (25)	12846	30.3%

Year
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	56.9 KiB

2020.0	1858
2019.0	1570
2021.0	1558
2018.0	1244
2017.0	1043

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	43638
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020.0
2nd row	2021.0
3rd row	2017.0
4th row	2018.0
5th row	2019.0

Common Values

Value	Count	Frequency (%)
2020.0	1858	25.5%
2019.0	1570	21.6%
2021.0	1558	21.4%
2018.0	1244	17.1%
2017.0	1043	14.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2020.0	1858	25.5%
2019.0	1570	21.6%
2021.0	1558	21.4%
2018.0	1244	17.1%
2017.0	1043	14.3%

Most occurring characters

Value	Count	Frequency (%)
0	16404	37.6%
2	10689	24.5%
.	7273	16.7%
1	5415	12.4%
9	1570	3.6%
8	1244	2.9%
7	1043	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	36365	83.3%
Other Punctuation	7273	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16404	45.1%
2	10689	29.4%
1	5415	14.9%
9	1570	4.3%
8	1244	3.4%
7	1043	2.9%

Other Punctuation

Value	Count	Frequency (%)
.	7273	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	43638	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16404	37.6%
2	10689	24.5%
.	7273	16.7%
1	5415	12.4%
9	1570	3.6%
8	1244	2.9%
7	1043	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43638	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16404	37.6%
2	10689	24.5%
.	7273	16.7%
1	5415	12.4%
9	1570	3.6%
8	1244	2.9%
7	1043	2.4%

ESG Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	7273
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.5951191

Minimum	5.114833664
Maximum	94.44445553
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	56.9 KiB

Quantile statistics

Minimum	5.114833664
5-th percentile	16.99017483
Q1	31.08531755
median	43.89661443
Q3	59.68062035
95-th percentile	78.64482082
Maximum	94.44445553
Range	89.32962187
Interquartile range (IQR)	28.5953028

Descriptive statistics

Standard deviation	18.86600105
Coefficient of variation (CV)	0.4137723823
Kurtosis	-0.728016009
Mean	45.5951191
Median Absolute Deviation (MAD)	14.05217136
Skewness	0.2459283091
Sum	331613.3012
Variance	355.9259955
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27.08101803	1	< 0.1%
39.77067073	1	< 0.1%
26.86161918	1	< 0.1%
28.01631135	1	< 0.1%
32.78846509	1	< 0.1%
30.88813499	1	< 0.1%
69.34418123	1	< 0.1%
61.58598124	1	< 0.1%
68.48282461	1	< 0.1%
49.97841456	1	< 0.1%
Other values (7263)	7263	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.114833664	1	< 0.1%
5.776484991	1	< 0.1%
5.974997495	1	< 0.1%
6.152221193	1	< 0.1%
6.221658567	1	< 0.1%
6.686398355	1	< 0.1%
6.81418215	1	< 0.1%
6.868101403	1	< 0.1%
6.966379589	1	< 0.1%
7.221805913	1	< 0.1%

Value	Count	Frequency (%)
94.44445553	1	< 0.1%
93.53912565	1	< 0.1%
93.32784124	1	< 0.1%
92.80650836	1	< 0.1%
92.61992314	1	< 0.1%
92.31516263	1	< 0.1%
92.1429952	1	< 0.1%
91.90508406	1	< 0.1%
91.85503349	1	< 0.1%
91.47686123	1	< 0.1%

Environmental Pillar Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6362
Distinct (%)	87.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.68848524

Minimum	0.027777778
Maximum	97.98022505
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	56.9 KiB

Quantile statistics

Minimum	0.027777778
5-th percentile	1.771771772
Q1	8.796296296
median	25.95088648
Q3	53.125
95-th percentile	81.67524908
Maximum	97.98022505
Range	97.95244727
Interquartile range (IQR)	44.3287037

Descriptive statistics

Standard deviation	26.34713048
Coefficient of variation (CV)	0.8060064664
Kurtosis	-0.8601953105
Mean	32.68848524
Median Absolute Deviation (MAD)	19.68115939
Skewness	0.5904826047
Sum	237743.3532
Variance	694.1712847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.740581784	52	0.7%
1.771771772	39	0.5%
1.608821403	33	0.5%
4.945054945	18	0.2%
37.31707317	18	0.2%
1.924818841	16	0.2%
6.302521008	16	0.2%
3.460972018	14	0.2%
3.236944325	14	0.2%
3	13	0.2%
Other values (6352)	7040	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.027777778	1	< 0.1%
0.086956522	1	< 0.1%
0.088593577	1	< 0.1%
0.142450142	1	< 0.1%
0.146297126	1	< 0.1%
0.194444444	1	< 0.1%
0.217013889	1	< 0.1%
0.255558395	1	< 0.1%
0.294612795	1	< 0.1%
0.308641975	1	< 0.1%

Value	Count	Frequency (%)
97.98022505	1	< 0.1%
97.69705095	1	< 0.1%
97.16815059	1	< 0.1%
97.16090883	1	< 0.1%
97.02299593	1	< 0.1%
96.67922137	1	< 0.1%
96.62206002	1	< 0.1%
96.54273654	1	< 0.1%
96.3344614	1	< 0.1%
96.07514881	1	< 0.1%

Social Pillar Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7242
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.40329011

Minimum	0.453490413
Maximum	97.83313378
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	56.9 KiB

Quantile statistics

Minimum	0.453490413
5-th percentile	15.33759499
Q1	30.70256215
median	45.91989914
Q3	63.01730829
95-th percentile	84.72395018
Maximum	97.83313378
Range	97.37964337
Interquartile range (IQR)	32.31474614

Descriptive statistics

Standard deviation	21.21297296
Coefficient of variation (CV)	0.4475000134
Kurtosis	-0.7505785007
Mean	47.40329011
Median Absolute Deviation (MAD)	16.05144928
Skewness	0.2364710717
Sum	344764.129
Variance	449.9902217
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28.95333105	4	0.1%
28.96555825	3	< 0.1%
50	3	< 0.1%
23.84305671	3	< 0.1%
22.47251138	3	< 0.1%
31.06869795	3	< 0.1%
25.1054216	3	< 0.1%
25.91686339	3	< 0.1%
37.5	2	< 0.1%
29.70593586	2	< 0.1%
Other values (7232)	7244	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.453490413	1	< 0.1%
1.250985028	1	< 0.1%
1.374185668	1	< 0.1%
2.058498218	1	< 0.1%
2.260348584	1	< 0.1%
2.440956221	1	< 0.1%
2.704071629	1	< 0.1%
2.708743072	1	< 0.1%
2.862323994	1	< 0.1%
2.868357488	1	< 0.1%

Value	Count	Frequency (%)
97.83313378	1	< 0.1%
97.66874295	1	< 0.1%
97.65506268	1	< 0.1%
97.57901244	1	< 0.1%
97.39413182	1	< 0.1%
97.39293525	1	< 0.1%
97.34833138	1	< 0.1%
97.25672305	1	< 0.1%
97.23474375	1	< 0.1%
97.15683466	1	< 0.1%

Governance Pillar Score
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7246
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53.30286473

Minimum	0.713528414
Maximum	99.49668624
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	56.9 KiB

Quantile statistics

Minimum	0.713528414
5-th percentile	16.39364647
Q1	36.92061081
median	54.97081144
Q3	70.36096517
95-th percentile	85.49530137
Maximum	99.49668624
Range	98.78315783
Interquartile range (IQR)	33.44035436

Descriptive statistics

Standard deviation	21.48435869
Coefficient of variation (CV)	0.4030619892
Kurtosis	-0.8086517305
Mean	53.30286473
Median Absolute Deviation (MAD)	16.55039119
Skewness	-0.2177612235
Sum	387671.7352
Variance	461.5776683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70.223046	2	< 0.1%
51.31558514	2	< 0.1%
60.88635921	2	< 0.1%
25.72314815	2	< 0.1%
24.66335863	2	< 0.1%
49.20694778	2	< 0.1%
35.74819745	2	< 0.1%
62.46257571	2	< 0.1%
50.8712963	2	< 0.1%
57.42315164	2	< 0.1%
Other values (7236)	7253	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.713528414	1	< 0.1%
1.21894023	1	< 0.1%
1.449805879	1	< 0.1%
1.621528968	1	< 0.1%
1.741942324	1	< 0.1%
1.77374894	1	< 0.1%
2.073211314	1	< 0.1%
2.223282443	1	< 0.1%
2.325063613	1	< 0.1%
2.462575706	1	< 0.1%

Value	Count	Frequency (%)
99.49668624	1	< 0.1%
98.61065544	1	< 0.1%
98.1416741	1	< 0.1%
97.5232521	1	< 0.1%
97.49964879	1	< 0.1%
97.30143852	1	< 0.1%
97.02811555	1	< 0.1%
96.77316411	1	< 0.1%
96.67393058	1	< 0.1%
96.59345871	1	< 0.1%

mean-return
Real number (ℝ)

HIGH CORRELATION

Distinct	7268
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.001136985144

Minimum	-0.552090105
Maximum	0.5359062215
Zeros	0
Zeros (%)	0.0%
Negative	3186
Negative (%)	43.8%
Memory size	56.9 KiB

Quantile statistics

Minimum	-0.552090105
5-th percentile	-0.07660494631
Q1	-0.01780396201
median	0.004320490956
Q3	0.0235602911
95-th percentile	0.06587996399
Maximum	0.5359062215
Range	1.087996327
Interquartile range (IQR)	0.04136425311

Descriptive statistics

Standard deviation	0.04781232323
Coefficient of variation (CV)	42.05184517
Kurtosis	13.28160525
Mean	0.001136985144
Median Absolute Deviation (MAD)	0.02032985182
Skewness	-0.9680795522
Sum	8.269292952
Variance	0.002286018253
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.06301338005	2	< 0.1%
0.03146094461	2	< 0.1%
0.01152288233	2	< 0.1%
1.513940488 × 10^-17	2	< 0.1%
0.039470474	2	< 0.1%
-0.06947842107	1	< 0.1%
-0.03050099186	1	< 0.1%
0.02415999341	1	< 0.1%
0.06235786844	1	< 0.1%
0.03056317333	1	< 0.1%
Other values (7258)	7258	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.552090105	1	< 0.1%
-0.5304138823	1	< 0.1%
-0.4925745599	1	< 0.1%
-0.3896555938	1	< 0.1%
-0.3346418915	1	< 0.1%
-0.3307936064	1	< 0.1%
-0.31315733	1	< 0.1%
-0.2974380222	1	< 0.1%
-0.2889139846	1	< 0.1%
-0.2830468463	1	< 0.1%

Value	Count	Frequency (%)
0.5359062215	1	< 0.1%
0.2835265788	1	< 0.1%
0.2558097662	1	< 0.1%
0.2494473479	1	< 0.1%
0.2376677679	1	< 0.1%
0.2321204633	1	< 0.1%
0.2282888654	1	< 0.1%
0.2206205853	1	< 0.1%
0.2199829472	1	< 0.1%
0.2096748972	1	< 0.1%

semi-variance (down)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
UNIQUE

Distinct	7273
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03301529356

Minimum	2.049697647 × 10^-6
Maximum	10.60379622
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	56.9 KiB

Quantile statistics

Minimum	2.049697647 × 10^-6
5-th percentile	0.001243005579
Q1	0.004228974024
median	0.01011033186
Q3	0.02653212721
95-th percentile	0.1172569894
Maximum	10.60379622
Range	10.60379417
Interquartile range (IQR)	0.02230315318

Descriptive statistics

Standard deviation	0.1617104052
Coefficient of variation (CV)	4.898045353
Kurtosis	2617.090121
Mean	0.03301529356
Median Absolute Deviation (MAD)	0.007417430372
Skewness	43.67768601
Sum	240.1202301
Variance	0.02615025515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.004021172732	1	< 0.1%
0.02582947016	1	< 0.1%
0.02049380886	1	< 0.1%
0.004465421519	1	< 0.1%
0.01445946784	1	< 0.1%
0.01063644202	1	< 0.1%
0.00529236128	1	< 0.1%
0.02166309697	1	< 0.1%
0.02236395096	1	< 0.1%
0.01191045911	1	< 0.1%
Other values (7263)	7263	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.049697647 × 10^-6	1	< 0.1%
5.055098442 × 10^-6	1	< 0.1%
5.08445488 × 10^-6	1	< 0.1%
5.274323069 × 10^-6	1	< 0.1%
6.131105551 × 10^-6	1	< 0.1%
8.070466148 × 10^-6	1	< 0.1%
1.132803218 × 10^-5	1	< 0.1%
1.166024936 × 10^-5	1	< 0.1%
1.237343283 × 10^-5	1	< 0.1%
1.319121727 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
10.60379622	1	< 0.1%
4.401274089	1	< 0.1%
2.814765903	1	< 0.1%
2.660379866	1	< 0.1%
2.528239724	1	< 0.1%
1.683931968	1	< 0.1%
1.273938367	1	< 0.1%
1.182263803	1	< 0.1%
1.162310479	1	< 0.1%
1.129021699	1	< 0.1%

kurtosis
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	7273
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7105823339

Minimum	-4.771690305
Maximum	10.66785002
Zeros	0
Zeros (%)	0.0%
Negative	3172
Negative (%)	43.6%
Memory size	56.9 KiB

Quantile statistics

Minimum	-4.771690305
5-th percentile	-1.375287965
Q1	-0.6194564829
median	0.2235622109
Q3	1.512164106
95-th percentile	4.510751604
Maximum	10.66785002
Range	15.43954032
Interquartile range (IQR)	2.131620589

Descriptive statistics

Standard deviation	1.865801242
Coefficient of variation (CV)	2.625735475
Kurtosis	2.221970281
Mean	0.7105823339
Median Absolute Deviation (MAD)	0.9802293374
Skewness	1.38930909
Sum	5168.065314
Variance	3.481214276
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.6328257409	1	< 0.1%
4.42868974	1	< 0.1%
2.783177392	1	< 0.1%
0.1109974028	1	< 0.1%
-0.8031782944	1	< 0.1%
0.1201461924	1	< 0.1%
-0.5098236926	1	< 0.1%
0.7872804591	1	< 0.1%
-0.6079825612	1	< 0.1%
1.294556822	1	< 0.1%
Other values (7263)	7263	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4.771690305	1	< 0.1%
-3.303480138	1	< 0.1%
-3.283662493	1	< 0.1%
-3.010231764	1	< 0.1%
-2.772284067	1	< 0.1%
-2.768118263	1	< 0.1%
-2.753330548	1	< 0.1%
-2.719587297	1	< 0.1%
-2.712449621	1	< 0.1%
-2.669416528	1	< 0.1%

Value	Count	Frequency (%)
10.66785002	1	< 0.1%
10.39619826	1	< 0.1%
10.39230482	1	< 0.1%
9.991123526	1	< 0.1%
9.330673785	1	< 0.1%
9.272796292	1	< 0.1%
9.136219555	1	< 0.1%
8.969254615	1	< 0.1%
8.909863957	1	< 0.1%
8.867227454	1	< 0.1%

skew
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	7273
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.1679193383

Minimum	-3.243905543
Maximum	3.118139779
Zeros	1
Zeros (%)	< 0.1%
Negative	4225
Negative (%)	58.1%
Memory size	56.9 KiB

Quantile statistics

Minimum	-3.243905543
5-th percentile	-1.661676494
Q1	-0.7366655895
median	-0.1743918841
Q3	0.4104441429
95-th percentile	1.322835232
Maximum	3.118139779
Range	6.362045322
Interquartile range (IQR)	1.147109732

Descriptive statistics

Standard deviation	0.8954242476
Coefficient of variation (CV)	-5.332466507
Kurtosis	0.2061299936
Mean	-0.1679193383
Median Absolute Deviation (MAD)	0.5719643003
Skewness	0.05438400105
Sum	-1221.277348
Variance	0.8017845832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.06114140649	1	< 0.1%
-1.597617659	1	< 0.1%
-0.9796808814	1	< 0.1%
-0.6968493832	1	< 0.1%
-0.3655078602	1	< 0.1%
-0.6439972632	1	< 0.1%
0.9276741452	1	< 0.1%
-0.728848908	1	< 0.1%
-0.1534623855	1	< 0.1%
0.6952662407	1	< 0.1%
Other values (7263)	7263	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3.243905543	1	< 0.1%
-3.192624611	1	< 0.1%
-3.192145101	1	< 0.1%
-2.95715309	1	< 0.1%
-2.91591035	1	< 0.1%
-2.8410198	1	< 0.1%
-2.816467798	1	< 0.1%
-2.803226022	1	< 0.1%
-2.794186419	1	< 0.1%
-2.792800808	1	< 0.1%

Value	Count	Frequency (%)
3.118139779	1	< 0.1%
2.939550184	1	< 0.1%
2.900624226	1	< 0.1%
2.846950478	1	< 0.1%
2.815081958	1	< 0.1%
2.781616199	1	< 0.1%
2.727624363	1	< 0.1%
2.674059504	1	< 0.1%
2.579003458	1	< 0.1%
2.575233083	1	< 0.1%

VaR (95%)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7271
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.1812995785

Minimum	-5.756462732
Maximum	0.05449763172
Zeros	1
Zeros (%)	< 0.1%
Negative	7254
Negative (%)	99.7%
Memory size	56.9 KiB

Quantile statistics

Minimum	-5.756462732
5-th percentile	-0.4711901745
Q1	-0.2285139713
median	-0.1372989011
Q3	-0.07893893959
95-th percentile	-0.03226260506
Maximum	0.05449763172
Range	5.810960364
Interquartile range (IQR)	0.1495750318

Descriptive statistics

Standard deviation	0.174921993
Coefficient of variation (CV)	-0.9648229435
Kurtosis	166.4759273
Mean	-0.1812995785
Median Absolute Deviation (MAD)	0.06885300129
Skewness	-7.360293362
Sum	-1318.591834
Variance	0.03059770363
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.2653141255	2	< 0.1%
-0.3465735903	2	< 0.1%
-0.07107546858	1	< 0.1%
-0.1767649292	1	< 0.1%
-0.2231626123	1	< 0.1%
-0.1451577862	1	< 0.1%
-0.03603184996	1	< 0.1%
-0.184144144	1	< 0.1%
-0.1483465567	1	< 0.1%
-0.1338984816	1	< 0.1%
Other values (7261)	7261	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5.756462732	1	< 0.1%
-3.453877639	1	< 0.1%
-1.669998066	1	< 0.1%
-1.64456756	1	< 0.1%
-1.627902163	1	< 0.1%
-1.609437912	1	< 0.1%
-1.565283421	1	< 0.1%
-1.530645946	1	< 0.1%
-1.466440804	1	< 0.1%
-1.440248505	1	< 0.1%

Value	Count	Frequency (%)
0.05449763172	1	< 0.1%
0.05115661859	1	< 0.1%
0.03287686949	1	< 0.1%
0.02703480588	1	< 0.1%
0.01351776512	1	< 0.1%
0.01006396599	1	< 0.1%
0.005793158139	1	< 0.1%
0.004990776787	1	< 0.1%
0.004271896986	1	< 0.1%
0.003945673828	1	< 0.1%

D(ESG, kurtosis)
Real number (ℝ_≥0)

MISSING

Distinct	2937
Distinct (%)	100.0%
Missing	4336
Missing (%)	59.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.709579019

Minimum	6.79050927 × 10^-8
Maximum	50.90867194
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	56.9 KiB

Quantile statistics

Minimum	6.79050927 × 10^-8
5-th percentile	0.006824963715
Q1	0.1760470753
median	0.8848366336
Q3	3.066449194
95-th percentile	12.4814052
Maximum	50.90867194
Range	50.90867188
Interquartile range (IQR)	2.890402118

Descriptive statistics

Standard deviation	4.706685144
Coefficient of variation (CV)	1.737054026
Kurtosis	18.45084039
Mean	2.709579019
Median Absolute Deviation (MAD)	0.8400479742
Skewness	3.586007949
Sum	7958.033579
Variance	22.15288504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.078563637	1	< 0.1%
5.80838985	1	< 0.1%
0.3522265929	1	< 0.1%
0.7981645858	1	< 0.1%
1.881086605	1	< 0.1%
4.724963344	1	< 0.1%
0.6789694413	1	< 0.1%
0.3202701144	1	< 0.1%
28.38155065	1	< 0.1%
0.5218527093	1	< 0.1%
Other values (2927)	2927	40.2%
(Missing)	4336	59.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.79050927 × 10^-8	1	< 0.1%
2.920950538 × 10^-6	1	< 0.1%
4.884088178 × 10^-6	1	< 0.1%
4.986095251 × 10^-6	1	< 0.1%
6.958513263 × 10^-6	1	< 0.1%
1.848653528 × 10^-5	1	< 0.1%
1.863846349 × 10^-5	1	< 0.1%
2.626211387 × 10^-5	1	< 0.1%
2.637262071 × 10^-5	1	< 0.1%
2.793033647 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
50.90867194	1	< 0.1%
45.29543076	1	< 0.1%
44.08411424	1	< 0.1%
40.11182434	1	< 0.1%
39.94788633	1	< 0.1%
38.52865772	1	< 0.1%
33.78034711	1	< 0.1%
33.49636273	1	< 0.1%
32.23911963	1	< 0.1%
31.06671918	1	< 0.1%

D(ESG, VaR)
Real number (ℝ_≥0)

MISSING

Distinct	5942
Distinct (%)	100.0%
Missing	1331
Missing (%)	18.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.033419998

Minimum	7.201370445 × 10^-8
Maximum	47.28022229
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	56.9 KiB

Quantile statistics

Minimum	7.201370445 × 10^-8
5-th percentile	0.003865694903
Q1	0.09087302745
median	0.3933587679
Q3	1.166821518
95-th percentile	3.91738911
Maximum	47.28022229
Range	47.28022221
Interquartile range (IQR)	1.07594849

Descriptive statistics

Standard deviation	2.110622726
Coefficient of variation (CV)	2.04236683
Kurtosis	125.297544
Mean	1.033419998
Median Absolute Deviation (MAD)	0.3625595722
Skewness	8.423620273
Sum	6140.581629
Variance	4.454728292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.305471268	1	< 0.1%
0.7236987708	1	< 0.1%
1.812275196	1	< 0.1%
0.7336866453	1	< 0.1%
1.219104989	1	< 0.1%
0.2087770395	1	< 0.1%
2.484205142	1	< 0.1%
0.848846879	1	< 0.1%
0.007135806447	1	< 0.1%
0.1170365531	1	< 0.1%
Other values (5932)	5932	81.6%
(Missing)	1331	18.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.201370445 × 10^-8	1	< 0.1%
1.615828905 × 10^-7	1	< 0.1%
3.591858258 × 10^-7	1	< 0.1%
5.596244496 × 10^-7	1	< 0.1%
7.547698111 × 10^-7	1	< 0.1%
9.188274723 × 10^-7	1	< 0.1%
1.053538485 × 10^-6	1	< 0.1%
1.207528765 × 10^-6	1	< 0.1%
2.423971339 × 10^-6	1	< 0.1%
2.98789117 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
47.28022229	1	< 0.1%
47.01104047	1	< 0.1%
37.17419917	1	< 0.1%
35.04497396	1	< 0.1%
28.14140719	1	< 0.1%
25.85330839	1	< 0.1%
22.90563473	1	< 0.1%
22.43001765	1	< 0.1%
20.23889516	1	< 0.1%
19.80086464	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Symbol	Year	ESG Score	Environmental Pillar Score	Social Pillar Score	Governance Pillar Score	mean-return	semi-variance (down)	kurtosis	skew	VaR (95%)	D(ESG, kurtosis)	D(ESG, VaR)
0	360.AX	2020.0	27.081018	8.916667	43.015144	18.809271	0.032846	0.004021	-0.632826	0.061141	-0.071075	NaN	NaN
1	360.AX	2021.0	31.410958	8.453608	45.972210	25.759307	0.025825	0.005839	1.742724	-0.646043	-0.075298	NaN	0.008210
2	A.N	2017.0	87.595065	77.060658	92.792375	85.667996	0.035512	0.007012	0.455790	0.720648	-0.096525	NaN	NaN
3	A.N	2018.0	89.489253	78.045737	94.201817	88.624684	-0.061043	0.004451	0.610308	0.850044	-0.162627	0.073191	0.250266
4	A.N	2019.0	88.330855	79.335997	94.505273	84.398806	-0.029269	0.016082	0.126243	-0.828252	-0.228490	2.442125	0.124653
5	A.N	2020.0	87.577489	79.958977	93.599370	83.203984	0.045653	0.270980	4.900414	-1.988309	-0.520227	13.450079	0.691122
6	AA.N	2017.0	87.273109	90.333748	79.472149	95.671099	-0.021786	0.002320	0.566293	-0.682118	-0.081101	7.558767	0.060957
7	AA.N	2018.0	86.619978	88.383537	79.128995	96.369097	-0.033796	0.006287	-0.703649	-0.791101	-0.137931	NaN	0.290054
8	AA.N	2019.0	88.078825	87.347163	83.474247	96.673931	-0.039699	0.015111	2.266191	-1.274915	-0.223285	NaN	0.216216
9	AA.N	2020.0	87.753771	86.773289	83.217569	96.593459	-0.037021	0.215737	5.702735	-2.142136	-0.557165	0.858482	0.842930

Last rows

	Symbol	Year	ESG Score	Environmental Pillar Score	Social Pillar Score	Governance Pillar Score	mean-return	semi-variance (down)	kurtosis	skew	VaR (95%)	D(ESG, kurtosis)	D(ESG, VaR)
7263	ZUMZ.OQ	2019.0	26.031559	5.594406	30.467751	31.321035	-0.037472	0.049756	3.683881	-1.761135	-0.314004	NaN	0.903151
7264	ZUMZ.OQ	2020.0	25.939660	4.883721	30.834082	31.029383	-0.005200	0.067349	0.572611	-0.974624	-0.385442	3.452085	0.043482
7265	ZUMZ.OQ	2021.0	24.257056	4.949495	27.183475	30.659259	0.021474	0.003797	3.069099	1.620179	-0.078603	3.048510	2.319293
7266	ZUO.N	2020.0	36.287529	3.083333	54.970658	30.160537	0.017291	0.018535	1.256732	-0.901465	-0.182401	NaN	NaN
7267	ZUO.N	2021.0	53.918785	27.848701	66.407377	50.985744	0.062855	0.002580	-0.551396	0.410789	-0.016845	NaN	7.718136
7268	ZWS.N	2017.0	21.756603	4.250060	27.085541	35.777625	-0.029082	0.107002	2.814027	-1.311767	-0.491496	NaN	0.894813
7269	ZWS.N	2018.0	22.966453	4.193398	24.531598	43.442041	-0.127620	0.074135	-1.053860	-0.274952	-0.461663	NaN	0.013628
7270	ZWS.N	2019.0	42.385059	47.923594	36.354082	43.646098	0.012917	0.035442	6.009275	2.079474	-0.296457	NaN	1.114489
7271	ZWS.N	2020.0	59.566298	53.797153	76.736643	43.977042	-0.038499	0.057422	-0.321493	-0.129591	-0.393005	NaN	0.003407
7272	ZWS.N	2021.0	59.809391	70.174636	76.569419	25.396839	-0.017465	0.010518	0.371196	1.074856	-0.182711	NaN	0.592885

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows